﻿CREATE TABLE [dbo].[Doctor]
(
	[ID] INT NOT NULL PRIMARY KEY IDENTITY, 
    [MemberID] INT NOT NULL, 
    [DepartmentId] INT NULL, 
    CONSTRAINT [FK_Doctor_ToMembers] FOREIGN KEY ([MemberID]) REFERENCES [Members]([Id]), 
    CONSTRAINT [FK_Doctor_Department] FOREIGN KEY ([DepartmentId]) REFERENCES [Department]([Id]) 
)
